For authentication, you can use an API signing key to connect to a
SQL Endpoint, or you can use a token (browser-based) to connect to a
SQL Endpoint. The connection uses SSL by default.
To use API key authentication
Optional Use the default OCI
configuration file and the default profile.
Optional If not using the default
location, append the OCI
configuration file location in the connection JDBC
URL. For example:
jdbc:spark:.interactive.dataflowclusters.us-phoenix-1.oci.oraclecloud.com/default;SparkServerType=DFI;OCIConfigFile=
Optional If not using the default
profile, append the OCI
profile lin the connection JDBC URL. For example:
jdbc:spark:.interactive.dataflowclusters.us-phoenix-1.oci.oraclecloud.com/default;SparkServerType=DFI;OCIConfigFile=OCIProfile=
To use a token (browser-based)
You can choose not to set up DFI Options entirely and
only test the DSN (step iv), or click DFI
Options and continue with the following steps:
If you don't have a default profile, don't
specify a profile in the JDBC URL. For example:
jdbc:spark:.interactive.dataflowclusters.us-phoenix-1.oci.oraclecloud.com/default;SparkServerType=DFI
A browser window opens where you sign in to the
tenancy where the Data Flow SQL Endpoint
is found.
|